class AddMissingIndexesTwo < ActiveRecord::Migration[5.2]
  def change
    add_index :active_shop_categories, :active_id
    add_index :active_shop_categories, :shop_category_id
    add_index :channels, :parent_id
    add_index :comment_pictures, :comment_id
    add_index :coupons, :shop_category_id
    add_index :coupons, :shop_id
    add_index :fare_mode_provinces, :fare_mode_id
    add_index :fare_mode_provinces, :province_id
    add_index :fare_modes, :fare_template_id
    add_index :fare_templates, :shop_id
    add_index :order_items, :refund_reason_id
    add_index :orders, :logistics_company_id
    add_index :refund_pictures, :order_item_id
    add_index :seckill_spus, :spu_id
    add_index :settles, :admin_id
    add_index :settles, :shop_id
    add_index :settles, :shoper_id
    add_index :shops, :shop_type_id
    add_index :spu_coupons, :coupon_id
    add_index :spu_coupons, :spu_id
    add_index :spu_tracks, :spu_id
    add_index :spu_tracks, :user_id
    add_index :spus, :fare_template_id
    add_index :user_coupons, :coupon_id
    add_index :user_coupons, :order_id
    add_index :user_coupons, :user_id
    add_index :user_search_keys, :user_id
  end
end
